package com.yuda.tools.authreport.mapper;


import com.yuda.tools.authreport.domain.OmsOrder;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OmsOrderMapper {

    List<OmsOrder> listShipped ();

    @Select("select CONCAT(a.exam_uuid,',',b.id_card) from oms_order a, baoming.sparta_student_account b \n" +
            "where a.open_id = b.uuid and a.status =2 and !ISNULL(a.exam_uuid) and a.delivery_time < #{time} \n")
    List<String> listStudentsForDeletePdf(String time);
}
